
/****** Object:  StoredProcedure [dbo].[web_change_user_status]    Script Date: 10/19/2013 09:22:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

--IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'web_change_user_status')
DROP PROCEDURE web_change_user_status
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[web_change_user_status] 
	@status varchar(50),
	@kodas varchar(50)
AS
BEGIN

	SET NOCOUNT ON
	
	UPDATE n60_asm SET n60_poz_date = @status WHERE n60_kodas_sm = @kodas AND n60_kodas_gs in ('WEB')
	

END

GO

